# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月14日
"""
import openpyxl

myBook = openpyxl.load_workbook('成绩表.xlsx')
mySheet=myBook['成绩表']
myRange=mySheet[str(mySheet.min_row+4):str(mySheet.max_row)]
mySumSheet=myBook.create_sheet('汇总表')
mySumSheet.append(['姓名','总分'])
for myRow in myRange:
	mySumSheet.append([myRow[0].value,sum([myCell.value for myCell in myRow][1:])])


myBook.save('结果表-成绩表.xlsx')
